Refer to Supported Spatial Databases

For an Oracle table to be recognized as a feature, the following criteria must also be met:

• The feature table must have a primary key constraint consisting of a single numeric or string/character column to represent the feature ID. This primary key is required to enable versioning using the standard versioning system of the Oracle Workspace Manager.

• The table must have a geometric (SDO_GEOMETRY) column specifying the feature geometry, and this geometry column must be registered in the Oracle spatial metadata table (ALL_SDO_GEOM_METADATA or the related USER_SDO_GEOM_METADATA view for the user).

• The table fields must be of a common type, not a user defined type.

• Geometry type support is restricted to point, multi point, curve, multi curve, polygon and multi polygon types. A table cannot have multiple geometry types.

  To determine if a table contains more than one geometry type, use the following query:

SELECT 
t.<geometry column>.SDO_GTYPE, 
COUNT(*) 
FROM<table name>t 
GROUP BY t<geometry column>.SDO_GTYPE;

GTYPE = 2001 = Points

GTYPE = 2002 = Lines

GTYPE = 2003 = Polygons

GTYPE = 2005 = Multipoints

GTYPE = 2006 = Multilines

GTYPE = 2007 = Multipolygons